Company X develops a laboratory information system (LIS) called System Y. The informationsystem has a two-tier database architecture consisting of a production database and a historicaldatabase. A database constitutes the backbone of a IS, which makes the design of the databasevery important. A poorly designed database can cause major problems within an organization.The two databases in System Y are poorly modeled, particularly the historical database. Thecause of the poor modeling was unclear concepts.

Creating a database to manage medical data is not the easiest. We create a database to be used for a presentation tool that presents medical data about patients that is stored in the database. We examine which of the three databases, MySQL with relational design, MySQL with EAV design and MongoDB that are best suited for storing medical data. The analysis i performed in two steps. The first step handles the database that is most effective to retriev data. The second step examines how easy it is to change the structure of the various databases. The results show that depending on whether efficiency or maintenance is most important, different databases are the best choise. MySQL with relational design proves to be most effective while MongoDB is the easiest to maintain..

Risk management is a key competency that is constantly being researched how it can be improved within project management. The risk management process consists of four major steps: identify risks, assess the risks? significance on the project, evaluate and address the key risks and follow up.The majority of companies seem to neglect certain identified risks, and decide not to mitigate if the risk does not cause adverse effects to the business. To counteract undesirable consequences and help organisations to become more effective at managing risks an initial work has been conducted for a risk repository.The project develops a proposal on the design of a risk repository which aim to effectively support a database implementation. The study includes literature studies which resulted in a relational model for database implementation.

The Center for Genomics and Bioinformatics (CGB) is an academic department at Karolinska Institute. Generally stated, the CGB department is committed to the generation and management of genetic information by approaches aiming at elucidating the connection between genes, protein and function.WiGID is a genome information database that is available through WAP (Wireless Application Protocol).Our version of WiGID is based on WML, PHP and PostgreSQL as a database server.One of the changes on the old WiGID application was the creation of a relational database with seven tables and one view, instead of the file that represented the database on the old version. We also changed the script language from python to PHP.The search engine ability has been extended with three new search alternatives for a user to choose from. Each choice leads to other, sometimes multiple choices.A GUI has been created for the administrator, to be able to insert information into the database.The structure of the search engine is primarily for narrowing down the search result on the phone display, thereby making the search efficient..

The purpose of this study was to build a database for point-bearing piles in dense noncohesive soil, predominantly moraine. Further, the database was analysed and areas with difficult geotechnical conditions was identified.The database includes for point-bearing piles driven to refusal in moraine. Piles with mainly shaft friction have been excluded. Only concrete piles have been included. Geographically the database covers almost all geotechnical conditions of Sweden.

The relational database model was defined in the 1970?s and is the dominating database type today.  The main difference between data from a relational database and a hierarchical data structure is that the relational database stores records in tables. The records have no particular order, but can include links in terms of relationships with other records. A hierarchical structure organizes data in the form of a tree structure  and  can for an example be found in organizational structures in which different levels involves different responsibilities. If the data stored in a relational database is to be presented in a hierarchically, a conversion of the data structure is required. The intention of this paper is to describe how such a conversion can be performed.  To investigate the conversion methods, case studies has been conducted on the basis of a specific organization?s hierarchical structure.

Risk management is a key competency that is constantly being researched how it can be improved within project management. The risk management process consists of four major steps: identify risks, assess the risks? significance on the project, evaluate and address the key risks and follow up.The majority of companies seem to neglect certain identified risks, and decide not to mitigate if the risk does not cause adverse effects to the business. To counteract undesirable consequences and help organisations to become more effective at managing risks an initial work has been conducted for a risk repository.The project develops a proposal on the design of a risk repository which aim to effectively support a database implementation. The study includes literature studies which resulted in a relational model for database implementation.

Databases are an easy way of storing information kept together and accessible and can save time by finding the information easier. Cochleaimplant could be seen as a form of advanced hearing aid, this product consists of two parts, an external part that recieves sound and sends signals to the internal part through electromagnetism. The internal part is the implant itself and is surgically placed in to the cochlea. Örebro University hospital has just started working within the field of Cochleaimplants and are therefore in need of a database to store patient related information.The database problem was solved using Microsoft Access 2003 combined with the built-in support for Visual Basic, which is a sort of programming language. The result of the thesis work was a fully functioning database according to the given specification and is now being used at Örebro University hospital..

The social community is structured around data, a lot of that data is stored in different types of databases. The meaning of this essay is to develop an interactive tool that will change the way database visualization is done, and also to research in which fields a tool of this type can be used. With the help of different methods we discovered areas where it could be of use, such as; presentation of a database, development and documentation of a database. The primary goal of the prototype was to make viewing of database structures easier, even people without prior database knowledge should be able to understand the structure. During the development we used prototypes.

Research is a time-consuming endeavor which requires appropriate tools to manage often vast amounts of information. Militarization 2.0 is a research project aiming to explore Militarization in social media. The aim of this project is to design a user interface for supporting researchers in projects involving large amounts of data in qualitative studies. The project will follow the design process of the first version of the Militarization 2.0 research database interface. The design process involves user studies, interviews and design and testing of paper and digital prototypes.

This report explains the need to develop a configuration manager that handles transmission equipment which exists in the Swedish Defence telecommunications network. The configuration module will display the configurations and compatibility among the equipment and their software which are all part of the network.Also included in this report are tools, methods and results for the development of a prototype for the configuration manager. The prototype consists fundamentally of a database assisted by a user friendly website.The transmission equipment handles a lot of important transmission of information and is in the hands of a department of SAAB, OFGCA, by orders from the Swedish Defence Materiel Administration (FMV). Within the work included in this order exists a continuous update of both software and hardware which the equipment consists of. Therefore it?s highly important that there is a monitoring of which of the software and hardware is compatible with one another, ensuring that the functions of the system work properly.The consistent updating has resulted in compatibility issues between components and because of this, a need for a configuration manager has arisen..

SMC is in the process of developing a micro simulation model. The existing micro simulation model developed at Cornell University for US data, CorSim, is one of the fundamental parts for the new micro simulation at SMC. To develop the Swedish model, Swedish data on all individuals in Sweden during 11 years are also available. These data are organized in a database. This paper describes the process of rebuilding the database to a more useful structure.

This thesis work is executed at Business Unit Ericsson Test Environment (BETE), in Linköping. BETE is the department at Ericsson, which is responsible for the operation and maintenance of the company's Operations Support System (OSS). Their management system was outdated and they wanted it to be updated and it also required new features. The database needed to be replaced and the data migrated to a new database without licensing costs. The system also needed a part where employees could manage existing users.As a programming language PHP was chosen for its dynamic possibilities, platform independence and good support for database intergration.

Due to a growing interest in communication in today?s society the demand for equipment that is used in communication networks increases while the competition between companies that produce this equipment grows. To meet the increasing demand and at the same time having a competitive product development many companies use some effective product design, such as the modular product design. When a modular product design is used it?s good to compare different module configurations for a certain product and to simplify these comparisons some tool can be used.

This paper examines the European Commission?s, newly established, ?Register of interest representatives? The analysis is divided in two parts, first I analyze the registers purpose, the kind, and detail, of information it contains and the different kinds of groups that are supposed to register. After that I analyze the organizations in the register more thoroughly, using a database of my own creation. The database was constructed with information drawn from the register, as well as information from external sources. Regarding the design and purpose of the register, I find that improvements in the design are needed, if the register is to fulfill its purpose.